{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["icai"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"icai","index":0,"n_rows":507,"n_cols":19,"rows_kept":507,"cut":false,"hidden":false,"merged":[[64,0,71,0],[5,0,6,0],[10,0,61,0],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[58,3,58,4],[77,3,77,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[62,3,62,4],[65,3,65,4],[78,0,94,0],[73,0,77,0],[1,2,1,3],[72,3,72,4],[73,3,73,4],[74,3,74,4],[61,3,61,4],[63,3,63,4],[45,3,45,4],[46,3,46,4],[75,3,75,4],[76,3,76,4],[70,3,70,4],[71,3,71,4],[53,3,53,4],[54,3,54,4],[0,1,0,4],[2,2,2,3],[64,3,64,4],[59,3,59,4],[47,3,47,4],[56,3,56,4],[57,3,57,4],[39,3,39,4],[40,3,40,4],[49,3,49,4],[48,3,48,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[55,3,55,4],[60,3,60,4]]}
[0,"DIAGNÓSTICO OBLIGACIONES DE TRANSPARENCIA"]
[1,"Sujeto Obligado: Simas Monclova-Frontera ","Fecha de evaluación:28/08/2023",null,"2° Trimestre 2023"]
[2,"Unidad de Atención:  Enrique Hernández Plata ","Responsable de la evaluación: revisado",null,"Sub. De Evaluación ICAI"]
[]
[null,"Obligación de transparencia","puntos","Observaciones"]
["Art. 18","I. Vinculo Transparencia",2]
[null,"IV. Buzón de quejas electrónico",2]
[null,"Obligación de transparencia","puntos","Observaciones"]
["Art. 20","Calendario Anual IPO",2]
[null,"Información pública de oficio","puntos","Observaciones"]
["Art. 21","I. Estructura Orgánica, facultades y responsabilidades",2,"Deberá publicar el organigrama de todos los colaboradores de la organización"]
[null,"II. Marco normativo aplicable",2]
[null,"III.  Directorio de Servidores Públicos",2,"Deberá publicar el correo electrónico de todos los colaboradores de la oganización"]
[null,"IV.Nombramientos, comisiones y licencias",2]
[null,"V. Remuneración mensual por puesto",1,"Deberá desglozar todas las percepciones y deducciones, ya que se publican en $0.00"]
[null,"VI. Versión pública de la declaración patrimonial",2]
[null,"VII. Importe por concepto de viáticos y gastos de representación",2]
[null,"VIII. Perfil de puestos y el curriculum de todos los servidores públicos",2]
[null,"IX. Convenios de colaboración y contratos que los sujetos obligados celebre",2]
[null,"X.  Condiciones generales de trabajo",1,"El contrato publicado expiró el 01 Mayo 2023. Deberá publicar un contrato vigente"]
[null,"XI. Planes, programas o proyectos con los indicadores de gestión",2]
[null,"XII. Listado con los servicios que ofrece, trámites, tiempos de respuesta, requisitos",2]
[null,"XIII. Mecanismo de solicitudes, opiniones, quejas",2]
[null,"XIV.    Mecanismo de participación ciudadana",2]
[null,"XV.  Programas de subsidio, estímulos y apoyos que ofrece y requisitos para acceder",2]
[null,"XVI. Beneficiarios de programas de subsidios, estímulos y apoyos",2]
[null,"XVII.  Los padrones de beneficiarios de los programas sociales",2]
[null,"XVIII. Listado de personas físicas o morales a quienes se les entregue o permita usar recursos públicos",2]
[null,"XIX. Listado de instituciones de beneficencia",2]
[null,"XX.  Para los últimos 3 ejercicios fiscales, en lo general y por programa.",2]
[null,"XXI.  Calendario de sesión o reuniones públicas",2]
[null,"XXII. Nombre, nombramiento, fotografía, domicilio y correo electrónico oficiales de los servidores públicos que integren la Unidad de Transparencia y el Comité de Transparencia, así como, un mapa georreferenciado de la ubicación donde se encuentran las oficinas o instalaciones de la Unidad de Transparencia; ",2]
[null,"XXIII. Catálogos documental",2]
[null,"XXIV.  Solicitudes de acceso a la información",2]
[null,"XXV. Informes de avances de gestión financiera trimestral y la cuenta pública anual",2]
[null,"XXVI. La deuda pública",2]
[null,"XXVII.  Los resultados de las auditorías",2]
[null,"XXVIII. Proveedores y contratistas",2]
[null,"XXIX. Inspectores o visitadores",2]
[null,"XXX. Los resultados sobre procedimientos de adjudicación directa, invitación restringida y licitación de cualquier naturaleza",2]
[null,"XXXI. La agenda mensual de eventos culturales o deportivos",2]
[null,"XXXII. Actas de entrega-recepción",2]
[null,"XXXIII.La georreferenciación de obras públicas",2]
[null,"XXXIV. Expedientes clasificados como reservados",2]
[null,"XXXV. Guía simple de los archivos",2]
[null,"XXXVI. Concesiones, permisos y autorizaciones",2]
[null,"XXXVII. Concesiones de transporte público",2]
[null,"XXXVIII. Entrega de recursos públicos",2]
[null,"XXXIX.  Sistemas de pensiones",2]
[null,"XL.Informe anual de actividades",2]
[null,"XLI. Estadísticas o indicadores sobre los ingresos",2]
[null,"XLII. Información desclasificada",2]
[null,"XLIII.  Preguntas más frecuentes",2]
[null,"XLIV. Catálogo de información adicional",2]
[null,"XLV. Informe de acciones realizadas por contingencias",2]
[null,"XLVI. Las aportaciones nacionales e internacionales, para ayudar a los municipios o comunidades en emergencia o desastre",2]
[null,"XLVII. El listado de servidores públicos con sanciones definitivas",2]
[null,"XLVIII. El listado del parque vehicular",2]
[null,"XLIX. Información catastral",2]
[null,"L. El proceso catastral de valuación de los predios",2]
[null,"LI. Los mecanismos y los resultados de la evaluación, investigación o la integración de expedientes que midan el impacto ambiental, social, demográfico o económico que se realicen para el desarrollo de planes o proyectos; y",2]
[null,"LII. Un informe de los resultados de las evaluaciones a que son sujetos de forma periódica y/o trimestral por parte del Instituto, con respecto al cumplimiento de las obligaciones previstas en esta ley cada seis años",1,"Deberá publicar la información en un cuadro indicando ejercicio, periodo y calificación, de los últimos 6 ejercicios."]
[null,"LIII. Cualquier otra información",2]
[null,"Gastos de publicidad oficial","puntos","Observaciones"]
["Art. 22","Presupuesto aprobado",2]
[null,"II.Contrato, monto y factura",2]
[null,"III.Nombre de la Campaña",2]
[null,"IV.Fecha de inicio y fecha de termino",2]
[null,"V.Dependencia o dirección que lo solicita",2]
[null,"VI.Tipo de medio de comunicación",2]
[null,"VII.Costo por cm o por seg",2]
[null,"VIII.Padrón de proveedores",2]
[null,"Obligaciones especificas","puntos","Observaciones"]
["Art. 30","I. Tarifas por sector y/o giro",2]
[null,"II. Teléfonos de atención, lugares de pago, calendario y horarios de distribución",2]
[null,"III. Los estudios y sus resultados que se realicen sobre la calidad del agua",2]
[null,"IV. Programa o lugar de explotación y el estado que guardan los pozos o fuentes de abastecimiento",2]
[null,"V. Los estudios y sus resultados que, en su caso, se realicen de los mantos acuíferos",2]
[]
[null,"Suma de puntos",{"$f":"S485","v":67.5}]
[null,"Porcentaje por cumplir",{"$f":"1-C82","v":2.1739130434782594E-2}]
[null,"Porcentaje Total de cumplimiento",{"$f":"C80/S489","v":0.97826086956521741}]
[]
[null,"No tiene información o no justifica la falta de la misma"]
[null,"Información desactualizada o incompleta"]
[null,"Información completa, confiable y oportuna"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Puntos",{"$f":"SUM(icai!C6:C7,icai!C9,icai!C11:C63,icai!C65:C72,icai!C74:C78,)","v":135},{"$f":"CONCATENATE(\"=suma(\",P480,P481,P482,P483,P484,P485,P486,P487,P488,P489,P490,P491,P492,P493,P494,P495,P496,P497,P498,P499,P500,P501,P502,P503,P504,P505,P506,P507,\")\")","v":"=suma('icai'!C6:C7,'icai'!C9,'icai'!C11:C63,'icai'!C64:C71,'icai'!C73:C77)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART 18","'icai'!C6:C7,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART 20","'icai'!C9,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART 21","'icai'!C11:C63,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART 22","'icai'!C64:C71,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART 28","'icai'!C73:C77"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART",null,null,"Reactivos",{"$f":"P479/2","v":67.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART",null,null,null,{"$f":"S485/2","v":33.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART",null,null,"Valores Reales",69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART",null,null,null,34.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ART"]